﻿CREATE proc NKNH_XoaChungTu_H
@so_ctu nvarchar(255)
as

if not exists (select*from NKNH_H where so_ctu=@so_ctu)
begin
select ErrCode=0
end
else
begin
delete from NKNH_H where so_ctu=@so_ctu
delete from NKNH_L where so_ctu=@so_ctu
select ErrCode=1
end